#!/usr/bin/env python
# -*- coding: utf-8 -*-
# @Author:    thepoy
# @Email:     thepoy@163.com
# @File Name: mysql_mysql-connector.py
# @Created:   2021-12-28 14:45:50
# @Modified:  2021-12-28 15:09:55

from mysql import connector


def main():
    conn = connector.connect(
        host="",
        user="",
        passwd="",
        database="",
        auth_plugin="mysql_native_password",
    )

    cur = conn.cursor()
    cur.execute("SELECT id FROM items LIMIT 1;")

    for row in cur:
        print(row)


if __name__ == "__main__":
    main()
